﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Entity
{

    /// <summary>
    /// 井相关的实体集
    /// </summary>

    public class tb_WellModel
    {

        #region 井基础数据
        //[Table("tb_Well")]
        /// <summary>
        /// 井
        /// </summary>
        public class Well
        {
            /// <summary>
            /// 表名
            /// </summary>
            public const string M_NAME = "tb_Well";
            /// <summary>
            /// 井号
            /// </summary>
            public string WellNo { get; set; }
            /// <summary>
            /// 区块ID
            /// </summary>
            public int? AreaID { get; set; }
            /// <summary>
            /// 井别
            /// </summary>
            public string WellType { get; set; }
            /// <summary>
            /// 地理位置
            /// </summary>
            public string Location { get; set; }
            /// <summary>
            /// 地面海拔(m)
            /// </summary>
            public decimal? WellAltitude { get; set; }
            /// <summary>
            /// 坐标X
            /// </summary>
            public decimal? Axis_x { get; set; }
            /// <summary>
            /// 坐标Y
            /// </summary>
            public decimal? Axis_y { get; set; }
            /// <summary>
            /// 目的层
            /// </summary>
            public string IntercalatedBed { get; set; }
            /// <summary>
            /// 完钻层位
            /// </summary>
            public string DrillingLayer { get; set; }
            /// <summary>
            /// 完钻井深
            /// </summary>
            public decimal? TotalDepth { get; set; }
            /// <summary>
            /// 人工井底
            /// </summary>
            public decimal? ArtificialHole { get; set; }
            /// <summary>
            /// 完钻方式
            /// </summary>
            public string DrillingWay { get; set; }
            /// <summary>
            /// 开钻日期
            /// </summary>
            public DateTime? SpudDate { get; set; }
            /// <summary>
            /// 完钻日期
            /// </summary>
            public DateTime? DrilledDate { get; set; }
            /// <summary>
            /// 完井日期
            /// </summary>
            public DateTime? CompletionDate { get; set; }
            /// <summary>
            /// 添加人
            /// </summary>
            public Guid UserID { get; set; }
            /// <summary>
            /// 添加时间
            /// </summary>
            public DateTime InputDate { get; set; }
        }
        #endregion

        #region 井身结构
        /// <summary>
        /// 井身结构
        /// </summary>
        //[Table("tb_HoleStructure")]
        public partial class tHoleStructure
        {
            /// <summary>
            /// 表名
            /// </summary>
            public const string M_NAME = "tb_HoleStructure";
            /// <summary>
            /// ID
            /// </summary>
            public int ID { get; set; }
            /// <summary>
            /// 井号
            /// </summary>
            public string WellNo { get; set; }
            /// <summary>
            /// 套管程序
            /// </summary>
            public string CasingProgram { get; set; }
            /// <summary>
            /// 井眼尺寸(mm)
            /// </summary>
            public decimal? HoleSize { get; set; }
            /// <summary>
            /// 完钻深度(m)
            /// </summary>
            public decimal? TotalDepth { get; set; }
            /// <summary>
            /// 套管尺寸(mm)
            /// </summary>
            public decimal? WellSize { get; set; }
            /// <summary>
            /// 开始位置(m)
            /// </summary>
            public decimal? StartLocation { get; set; }
            /// <summary>
            /// 结束位置(m)
            /// </summary>
            public decimal? EndLocation { get; set; }
            /// <summary>
            /// 水泥反深(m)
            /// </summary>
            public decimal? CementDepth { get; set; }
            /// <summary>
            /// 添加人
            /// </summary>
            public Guid UserID { get; set; }
            /// <summary>
            /// 添加时间
            /// </summary>
            public DateTime InputDate { get; set; }
        }
        #endregion

        #region 井眼轨迹
        /// <summary>
        /// 井眼轨迹
        /// </summary>
        //[Table("tb_WellTrajectory")]
        public class WellTrajectory
        {
            /// <summary>
            /// 表名
            /// </summary>
            public const string M_NAME = "tb_WellTrajectory";
            /// <summary>
            /// 编号
            /// </summary>
            public int ID { get; set; }
            /// <summary>
            /// 井号
            /// </summary>
            public string WellNo { get; set; }
            /// <summary>
            /// 井深
            /// </summary>
            public decimal WellDepth { get; set; }
            /// <summary>
            /// 井斜角(°)
            /// </summary>
            public decimal InclinationAngle { get; set; }
            /// <summary>
            /// 方位角(°)
            /// </summary>
            public decimal AzimuthAngle { get; set; }
            /// <summary>
            /// 垂深(m)
            /// </summary>
            public decimal? VerticalDepth { get; set; }
            /// <summary>
            /// +北/-南(m)
            /// </summary>
            public decimal? NorthOrSouth { get; set; }
            /// <summary>
            /// +东/-西(m)
            /// </summary>
            public decimal? EastOrWest { get; set; }
            /// <summary>
            /// 狗腿度(°/30m)
            /// </summary>
            public decimal? DoglegDegree { get; set; }
            /// <summary>
            /// 造斜率(°/30m)
            /// </summary>
            public decimal? BuildUpRate { get; set; }
            /// <summary>
            /// 备注
            /// </summary>
            public string Note { get; set; }
            /// <summary>
            /// 添加人
            /// </summary>
            public Guid UserID { get; set; }
            /// <summary>
            /// 添加时间
            /// </summary>
            public DateTime InputDate { get; set; }
        } 
        #endregion
    }
}
